[dbo].[CertificationModuleRegistration]

Property	Value
Created	3:11:55 PM Friday, January 07, 2011
Last Modified	1:17:31 PM Thursday, February 23, 2012

Name	Data Type	Max Length (Bytes)
CertificationModuleRegistrationKey	uniqueidentifier	16
CertificationProgramRegistrationKey	uniqueidentifier	16
CertificationModuleKey	uniqueidentifier	16
CustomerExperienceKey	uniqueidentifier	16
RegistrationDate	datetime	8
RegistrationStatusCode	char(2)	2
EarnedUnits	decimal(18,9)	9

	Name	Columns	Unique
	PK_CertificationModuleRegistration	CertificationModuleRegistrationKey
	IX_CertificationModuleRegistration_CertificationModuleKey	CertificationModuleKey
	IX_CertificationModuleRegistration_CertificationProgramRegistrationKey	CertificationProgramRegistrationKey
	IX_CertificationModuleRegistration_CustomerExperienceKey	CustomerExperienceKey
	IX_CertificationModuleRegistration_RegistrationStatusCode	RegistrationStatusCode

Name	Columns
FK_CertificationModuleRegistration_CertificationModule	CertificationModuleKey->[dbo].[CertificationModule].[CertificationModuleKey]
FK_CertificationModuleRegistration_CertificationProgramRegistration	CertificationProgramRegistrationKey->[dbo].[CertificationProgramRegistration].[CertificationProgramRegistrationKey]
FK_CertificationModuleRegistration_OfferedCustomerExperience	CustomerExperienceKey->[dbo].[CustomerExperience].[CustomerExperienceKey]
FK_CertificationModuleRegistration_RegistrationStatusRef	RegistrationStatusCode->[dbo].[RegistrationStatusRef].[RegistrationStatusCode]

SQL Script

CREATE TABLE [dbo].[CertificationModuleRegistration]
(
[CertificationModuleRegistrationKey] [uniqueidentifier] NOT NULL,
[CertificationProgramRegistrationKey] [uniqueidentifier] NOT NULL,
[CertificationModuleKey] [uniqueidentifier] NOT NULL,
[CustomerExperienceKey] [uniqueidentifier] NULL,
[RegistrationDate] [datetime] NOT NULL,
[RegistrationStatusCode] [char] (2) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[EarnedUnits] [decimal] (18, 9) NULL
) ON [PRIMARY]

GO
ALTER TABLE [dbo].[CertificationModuleRegistration] ADD CONSTRAINT [PK_CertificationModuleRegistration] PRIMARY KEY CLUSTERED ([CertificationModuleRegistrationKey]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_CertificationModuleRegistration_CertificationModuleKey] ON [dbo].[CertificationModuleRegistration] ([CertificationModuleKey]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_CertificationModuleRegistration_CertificationProgramRegistrationKey] ON [dbo].[CertificationModuleRegistration] ([CertificationProgramRegistrationKey]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_CertificationModuleRegistration_CustomerExperienceKey] ON [dbo].[CertificationModuleRegistration] ([CustomerExperienceKey]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_CertificationModuleRegistration_RegistrationStatusCode] ON [dbo].[CertificationModuleRegistration] ([RegistrationStatusCode]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[CertificationModuleRegistration] ADD CONSTRAINT [FK_CertificationModuleRegistration_CertificationModule] FOREIGN KEY ([CertificationModuleKey]) REFERENCES [dbo].[CertificationModule] ([CertificationModuleKey])
GO
ALTER TABLE [dbo].[CertificationModuleRegistration] ADD CONSTRAINT [FK_CertificationModuleRegistration_CertificationProgramRegistration] FOREIGN KEY ([CertificationProgramRegistrationKey]) REFERENCES [dbo].[CertificationProgramRegistration] ([CertificationProgramRegistrationKey])
GO
ALTER TABLE [dbo].[CertificationModuleRegistration] ADD CONSTRAINT [FK_CertificationModuleRegistration_OfferedCustomerExperience] FOREIGN KEY ([CustomerExperienceKey]) REFERENCES [dbo].[CustomerExperience] ([CustomerExperienceKey])
GO
ALTER TABLE [dbo].[CertificationModuleRegistration] ADD CONSTRAINT [FK_CertificationModuleRegistration_RegistrationStatusRef] FOREIGN KEY ([RegistrationStatusCode]) REFERENCES [dbo].[RegistrationStatusRef] ([RegistrationStatusCode])
GO